/*
 Navicat Premium Data Transfer

 Source Server         : 192.168.1.2
 Source Server Type    : MySQL
 Source Server Version : 50736
 Source Host           : 192.168.1.2
 Source Database       : mybatis

 Target Server Type    : MySQL
 Target Server Version : 50736
 File Encoding         : utf-8

 Date: 04/11/2022 14:18:08 PM
*/

SET NAMES utf8;
SET FOREIGN_KEY_CHECKS = 0;

-- ----------------------------
--  Table structure for `goods`
-- ----------------------------
DROP TABLE IF EXISTS `goods`;
CREATE TABLE `goods` (
  `gid` int(11) NOT NULL,
  `goods_name` varchar(255) DEFAULT NULL COMMENT '商品名称',
  `amount` int(11) DEFAULT NULL COMMENT '商品数量',
  `price` float DEFAULT NULL COMMENT '商品价格',
  PRIMARY KEY (`gid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

BEGIN;
INSERT INTO `goods` VALUES ('1001', '笔记本电脑', '100', '6000'), ('1002', '手机', '50', '3000');
COMMIT;

SET FOREIGN_KEY_CHECKS = 1;
